/*
 Navicat MySQL Data Transfer

 Source Server         : 个人服务器
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 140.143.17.204:3306
 Source Schema         : hrms

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 17/11/2019 19:34:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for adjustsalary
-- ----------------------------
DROP TABLE IF EXISTS `adjustsalary`;
CREATE TABLE `adjustsalary` (
  `id` varchar(32) NOT NULL,
  `eid` varchar(32) DEFAULT NULL,
  `asDate` datetime DEFAULT NULL COMMENT '调薪日期',
  `beforeSalary` int(11) DEFAULT NULL COMMENT '调前薪资',
  `afterSalary` int(11) DEFAULT NULL COMMENT '调后薪资',
  `reason` varchar(255) DEFAULT NULL COMMENT '调薪原因',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for appraise
-- ----------------------------
DROP TABLE IF EXISTS `appraise`;
CREATE TABLE `appraise` (
  `id` varchar(32) NOT NULL,
  `eid` varchar(32) DEFAULT NULL,
  `appDate` datetime DEFAULT NULL COMMENT '考评日期',
  `appResult` varchar(32) DEFAULT NULL COMMENT '考评结果',
  `appContent` varchar(255) DEFAULT NULL COMMENT '考评内容',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` varchar(32) NOT NULL,
  `name` varchar(32) DEFAULT NULL COMMENT '部门名称',
  `parentId` varchar(32) DEFAULT NULL,
  `depPath` varchar(4096) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `isParent` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of department
-- ----------------------------
BEGIN;
INSERT INTO `department` VALUES ('1', '股东会', '-1', '.1', 1, 1);
INSERT INTO `department` VALUES ('4', '董事会', '1', '.1.4', 1, 1);
INSERT INTO `department` VALUES ('5', '总办', '4', '.1.4.5', 1, 1);
INSERT INTO `department` VALUES ('78', '市场部', '5', '.1.4.5.78', 1, 1);
INSERT INTO `department` VALUES ('8', '财务部', '5', '.1.4.5.8', 1, 0);
INSERT INTO `department` VALUES ('81', '华北市场部', '78', '.1.4.5.78.81', 1, 1);
INSERT INTO `department` VALUES ('82', '华南市场部', '78', '.1.4.5.78.82', 1, 0);
INSERT INTO `department` VALUES ('85', '石家庄市场部', '81', '.1.4.5.78.81.85', 1, 0);
INSERT INTO `department` VALUES ('86', '西北市场部', '78', '.1.4.5.78.86', 1, 1);
INSERT INTO `department` VALUES ('87', '西安市场', '86', '.1.4.5.78.86.87', 1, 1);
INSERT INTO `department` VALUES ('89', '莲湖区市场', '87', '.1.4.5.78.86.87.89', 1, 0);
INSERT INTO `department` VALUES ('91', '技术部', '5', '.1.4.5.91', 1, 0);
INSERT INTO `department` VALUES ('92', '运维部', '5', '.1.4.5.92', 1, 0);
INSERT INTO `department` VALUES ('97963375920676864SKF', '北京市场部', '78', '.1.4.5.78.97963375920676864SKF', 1, 1);
INSERT INTO `department` VALUES ('97967239021461504WXG', '清华市场部', '97963375920676864SKF', '.1.4.5.78.97963375920676864SKF.97967239021461504WXG', 1, 0);
INSERT INTO `department` VALUES ('97967852186763264LEV', '海淀市场部', '97963375920676864SKF', '.1.4.5.78.97963375920676864SKF.97967852186763264LEV', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `id` varchar(32) NOT NULL COMMENT '员工编号',
  `name` varchar(10) DEFAULT NULL COMMENT '员工姓名',
  `gender` char(4) DEFAULT NULL COMMENT '性别',
  `birthday` datetime DEFAULT NULL COMMENT '出生日期',
  `idCard` char(18) DEFAULT NULL COMMENT '身份证号',
  `wedlock` enum('已婚','未婚','离异') DEFAULT NULL COMMENT '婚姻状况',
  `nationId` varchar(32) DEFAULT NULL COMMENT '民族',
  `nativePlace` varchar(20) DEFAULT NULL COMMENT '籍贯',
  `politicId` varchar(32) DEFAULT NULL COMMENT '政治面貌',
  `email` varchar(20) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(11) DEFAULT NULL COMMENT '电话号码',
  `address` varchar(64) DEFAULT NULL COMMENT '联系地址',
  `departmentId` varchar(32) DEFAULT NULL COMMENT '所属部门',
  `jobLevelId` varchar(32) DEFAULT NULL COMMENT '职称ID',
  `posId` varchar(32) DEFAULT NULL COMMENT '职位ID',
  `engageForm` varchar(8) DEFAULT NULL COMMENT '聘用形式',
  `tiptopDegree` enum('博士','硕士','本科','大专','高中','初中','小学','其他') DEFAULT NULL COMMENT '最高学历',
  `specialty` varchar(32) DEFAULT NULL COMMENT '所属专业',
  `school` varchar(32) DEFAULT NULL COMMENT '毕业院校',
  `beginDate` datetime DEFAULT NULL COMMENT '入职日期',
  `workState` enum('在职','离职') DEFAULT '在职' COMMENT '在职状态',
  `workID` char(8) DEFAULT NULL COMMENT '工号',
  `contractTerm` double DEFAULT NULL COMMENT '合同期限',
  `conversionTime` datetime DEFAULT NULL COMMENT '转正日期',
  `notWorkDate` datetime DEFAULT NULL COMMENT '离职日期',
  `beginContract` datetime DEFAULT NULL COMMENT '合同起始日期',
  `endContract` datetime DEFAULT NULL COMMENT '合同终止日期',
  `workAge` int(11) DEFAULT NULL COMMENT '工龄',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of employee
-- ----------------------------
BEGIN;
INSERT INTO `employee` VALUES ('10', '张洁', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000010', 1, '2018-01-31 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('11', '江南一点雨2', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '91', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000011', 1, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('12', '陈静2', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000012', 3, '2015-09-10 00:00:00', NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('13', '赵琳浩2', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000013', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1351', '江南一点雨', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000001', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1352', '陈静', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000002', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1357', '贾旭明', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000007', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1358', '张黎明', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000008', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1359', '薛磊', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000009', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1360', '张洁', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000010', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1361', '江南一点雨2', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000011', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1362', '陈静2', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000012', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1363', '赵琳浩2', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000013', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1364', '鹿存亮2', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000014', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1365', '姚森2', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000015', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1366', '云星2', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000016', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1367', '贾旭明2', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000017', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1368', '王一亭', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000018', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1369', '薛磊2', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000019', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1370', '张洁2', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000020', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1371', '江南一点雨3', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000021', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1372', '陈静3', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000022', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1373', '鹿存亮3', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000024', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1374', '姚森3', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000025', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1375', '云星3', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000026', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1376', '贾旭明3', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000027', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1377', '张黎明3', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000028', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1378', '薛磊3', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000029', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1379', '江南一点雨4', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000031', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1380', '陈静4', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000032', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1381', '赵琳浩4', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000033', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1382', '鹿存亮4', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000034', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1383', '姚森4', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000035', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1384', '云星4', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000036', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1385', '贾旭明4', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000037', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('14', '鹿存亮2', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000014', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1411', '谢工', '女', '1970-01-01 00:00:00', '618177197001011234', '离异', '1', '江苏', '1', '584991843@qq.com', '18558887788', '北京', '91', '12', '29', '劳动合同', '本科', '计算机软件', '南华大学', '2018-01-01 00:00:00', '在职', '00000038', 5, '2019-01-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1412', '林昭亮', '男', '1990-01-01 00:00:00', '610122199809091234', '已婚', '1', '广东', '13', '584991843@qq.com', '16767776654', '广东深圳', '91', '15', '33', '劳动合同', '大专', '计算机软件', '广东职业技术学院', '2018-01-01 00:00:00', '在职', '00000039', 5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1413', '11', '男', '2018-01-01 00:00:00', '610122201801011234', '已婚', '1', '1', '1', '584991843@qq.com', '111', '1', '89', '9', '29', '劳动合同', '本科', '1', '1', '2018-01-01 00:00:00', '在职', '00000040', 4, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2022-01-26 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1414', '1', '男', '2018-01-01 00:00:00', '610188199809091234', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '89', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000041', 1, '2018-01-31 00:00:00', NULL, '2018-01-31 00:00:00', '2019-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1415', '1', '男', '2018-01-01 00:00:00', '610122199909090000', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '78', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000042', 1, '2018-01-31 00:00:00', NULL, '2018-01-31 00:00:00', '2019-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1416', '1', '男', '2018-01-01 00:00:00', '610122199909090000', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '81', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000043', 0, '2018-01-31 00:00:00', NULL, '2018-01-31 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1417', '1', '男', '2018-01-01 00:00:00', '610122199909099999', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '87', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-01 00:00:00', '在职', '00000044', 0, '2018-01-01 00:00:00', NULL, '2018-01-01 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1418', '1', '男', '2018-01-01 00:00:00', '610122199909099999', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '78', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-01 00:00:00', '在职', '00000045', 0, '2018-01-01 00:00:00', NULL, '2018-01-01 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1419', '林伯渠', '男', '2018-01-01 00:00:00', '610122199909099999', '未婚', '1', '1', '1', '584991843@qq.com', '1', '1', '8', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000046', 0, '2018-01-31 00:00:00', NULL, '2018-01-31 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1420', '1', '男', '2018-01-01 00:00:00', '610122199909091234', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '8', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000047', 0, '2018-01-31 00:00:00', NULL, '2018-01-31 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1421', '江南一点雨', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '5', '9', '29', '劳务合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000001', 2, NULL, NULL, '2018-01-01 00:00:00', '2020-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1422', '陈静', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '8', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000002', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1423', '赵琳浩', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000003', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1424', '鹿存亮', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000004', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1425', '姚森', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '硕士', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000005', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1426', '云星', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000006', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1427', '贾旭明', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000007', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1428', '张黎明', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000008', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1429', '薛磊', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000009', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1430', '张洁', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000010', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1431', '江南一点雨2', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '91', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000011', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1432', '陈静2', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000012', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1433', '赵琳浩2', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000013', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1434', '鹿存亮2', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000014', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1435', '姚森2', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000015', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1436', '云星2', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000016', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1437', '贾旭明2', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000017', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1438', '王一亭', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000018', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1439', '薛磊2', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000019', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1440', '张洁2', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000020', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1441', '江南一点雨3', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000021', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1442', '陈静3', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000022', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1443', '鹿存亮3', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000024', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1444', '姚森3', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000025', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1445', '云星3', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000026', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1446', '贾旭明3', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000027', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1447', '张黎明3', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000028', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1448', '薛磊3', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000029', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1449', '江南一点雨4', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000031', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1450', '陈静4', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000032', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1451', '赵琳浩4', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000033', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1452', '鹿存亮4', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000034', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1453', '姚森4', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000035', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1454', '云星4', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000036', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1455', '贾旭明4', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000037', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1456', '张黎明2', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000038', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1457', '薛磊4', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000039', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1458', '张洁4', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000040', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1459', '江南一点雨5', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000041', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1460', '陈静5', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000042', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1461', '赵琳浩5', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000043', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1462', '鹿存亮5', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000044', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1463', '姚森5', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000045', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1464', '云星5', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000046', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1465', '贾旭明5', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000047', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1466', '张黎明5', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000048', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1467', '薛磊5', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000049', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1468', '张洁5', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000050', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1469', '江南一点雨6', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000051', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1470', '陈静6', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000052', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1471', '赵琳浩6', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000053', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1472', '鹿存亮6', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000054', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1473', '姚森6', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000055', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1474', '云星6', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000056', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1475', '江南一点雨', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000001', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1476', '陈静', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000002', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1477', '赵琳浩', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000003', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1478', '鹿存亮', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000004', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1479', '姚森', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000005', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1480', '贾旭明', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000007', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1481', '张黎明', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000008', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1482', '薛磊', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000009', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1483', '张洁', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000010', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1484', '江南一点雨2', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000011', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1485', '陈静2', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000012', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1486', '赵琳浩2', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000013', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1487', '鹿存亮2', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000014', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1488', '姚森2', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000015', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1489', '云星2', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000016', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1490', '贾旭明2', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000017', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1491', '王一亭', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000018', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1492', '薛磊2', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000019', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1493', '张洁2', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000020', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1494', '江南一点雨3', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000021', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1495', '陈静3', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000022', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1496', '鹿存亮3', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000024', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1497', '姚森3', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000025', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1498', '云星3', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000026', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1499', '贾旭明3', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000027', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('15', '姚森2', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000015', 7, '2017-04-02 00:00:00', NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1500', '张黎明3', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000028', 7, NULL, NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1501', '薛磊3', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000029', 6, NULL, NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1502', '江南一点雨4', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000031', 1, NULL, NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1503', '陈静4', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000032', 3, NULL, NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1504', '赵琳浩4', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000033', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1505', '鹿存亮4', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000034', 3.5, NULL, NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1506', '姚森4', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000035', 7, NULL, NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1507', '云星4', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000036', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1508', '贾旭明4', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000037', 5.25, NULL, NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1509', '谢工', '女', '1970-01-01 00:00:00', '618177197001011234', '离异', '1', '江苏', '1', '584991843@qq.com', '18558887788', '北京', '91', '12', '29', '劳动合同', '本科', '计算机软件', '南华大学', '2018-01-01 00:00:00', '在职', '00000038', 5, NULL, NULL, '2018-01-01 00:00:00', '2023-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1510', '林昭亮', '男', '1990-01-01 00:00:00', '610122199809091234', '已婚', '1', '广东', '13', '584991843@qq.com', '16767776654', '广东深圳', '91', '15', '33', '劳动合同', '大专', '计算机软件', '广东职业技术学院', '2018-01-01 00:00:00', '在职', '00000039', 5, NULL, NULL, '2018-01-01 00:00:00', '2023-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1511', '11', '男', '2018-01-01 00:00:00', '610122201801011234', '已婚', '1', '1', '1', '584991843@qq.com', '111', '1', '89', '9', '29', '劳动合同', '本科', '1', '1', '2018-01-01 00:00:00', '在职', '00000040', 4, NULL, NULL, '2018-01-01 00:00:00', '2022-01-26 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1512', '1', '男', '2018-01-01 00:00:00', '610188199809091234', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '89', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000041', 1, NULL, NULL, '2018-01-31 00:00:00', '2019-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1513', '1', '男', '2018-01-01 00:00:00', '610122199909090000', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '78', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000042', 1, NULL, NULL, '2018-01-31 00:00:00', '2019-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1514', '1', '男', '2018-01-01 00:00:00', '610122199909090000', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '81', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000043', 0, NULL, NULL, '2018-01-31 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1515', '1', '男', '2018-01-01 00:00:00', '610122199909099999', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '87', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-01 00:00:00', '在职', '00000044', 0, NULL, NULL, '2018-01-01 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1516', '1', '男', '2018-01-01 00:00:00', '610122199909099999', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '78', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-01 00:00:00', '在职', '00000045', 0, NULL, NULL, '2018-01-01 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1517', '林伯渠', '男', '2018-01-01 00:00:00', '610122199909099999', '未婚', '1', '1', '1', '584991843@qq.com', '1', '1', '8', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000046', 0, NULL, NULL, '2018-01-31 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('1518', '1', '男', '2018-01-01 00:00:00', '610122199909091234', '已婚', '1', '1', '1', '584991843@qq.com', '1', '1', '8', '9', '29', '劳动合同', '大专', '1', '1', '2018-01-31 00:00:00', '在职', '00000047', 0, NULL, NULL, '2018-01-31 00:00:00', '2018-01-31 00:00:00', NULL);
INSERT INTO `employee` VALUES ('16', '云星2', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000016', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('17', '贾旭明2', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000017', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('18', '王一亭', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000018', 7, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('19', '薛磊2', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000019', 1, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('2', '陈静', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '8', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000002', 3, '2015-09-10 00:00:00', NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('20', '张洁2', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000020', 1, '2018-01-31 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('21', '江南一点雨3', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000021', 1, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('22', '陈静3', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000022', 3, '2015-09-10 00:00:00', NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('24', '鹿存亮3', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000024', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('25', '姚森3', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000025', 7, '2017-04-02 00:00:00', NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('26', '云星3', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000026', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('27', '贾旭明3', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000027', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('28', '张黎明3', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000028', 7, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('29', '薛磊3', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000029', 6, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('3', '赵琳浩', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000003', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('31', '江南一点雨4', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000031', 1, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('32', '陈静4', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000032', 3, '2015-09-10 00:00:00', NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('33', '赵琳浩4', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000033', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('34', '鹿存亮4', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000034', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('35', '姚森4', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000035', 7, '2017-04-02 00:00:00', NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('36', '云星4', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000036', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('37', '贾旭明4', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000037', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('38', '张黎明2', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000038', 7, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('39', '薛磊4', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000039', 6, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('4', '鹿存亮', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000004', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('40', '张洁4', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000040', 1, '2018-01-31 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('41', '江南一点雨5', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000041', 1, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('42', '陈静5', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000042', 3, '2015-09-10 00:00:00', NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('43', '赵琳浩5', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000043', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('44', '鹿存亮5', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000044', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('45', '姚森5', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000045', 7, '2017-04-02 00:00:00', NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('46', '云星5', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000046', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('47', '贾旭明5', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000047', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('48', '张黎明5', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000048', 7, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('49', '薛磊5', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000049', 6, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('5', '姚森', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '硕士', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000005', 7, '2017-04-02 00:00:00', NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('50', '张洁5', '女', '1990-10-09 00:00:00', '420177199010093652', '未婚', '1', '海南', '5', 'zhangjie@qq.com', '13695557742', '海口市美兰区', '92', '16', '34', '劳动合同', '高中', '无', '海南侨中', '2018-01-01 00:00:00', '在职', '00000050', 1, '2018-01-31 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('51', '江南一点雨6', '男', '1990-01-01 00:00:00', '610122199001011256', '已婚', '1', '陕西', '13', 'laowang@qq.com', '18565558897', '深圳市南山区', '8', '9', '29', '劳动合同', '本科', '信息管理与信息系统', '深圳大学', '2018-01-01 00:00:00', '在职', '00000051', 1, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2019-01-01 00:00:00', NULL);
INSERT INTO `employee` VALUES ('52', '陈静6', '女', '1989-02-01 00:00:00', '421288198902011234', '已婚', '1', '海南', '1', 'chenjing@qq.com', '18795556693', '海南省海口市美兰区', '82', '12', '30', '劳动合同', '高中', '市场营销', '武汉大学', '2015-06-09 00:00:00', '在职', '00000052', 3, '2015-09-10 00:00:00', NULL, '2015-06-09 00:00:00', '2018-06-08 00:00:00', NULL);
INSERT INTO `employee` VALUES ('53', '赵琳浩6', '男', '1993-03-04 00:00:00', '610122199303041456', '未婚', '1', '陕西', '3', 'zhao@qq.com', '15698887795', '陕西省西安市莲湖区', '91', '12', '33', '劳动合同', '博士', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000053', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('54', '鹿存亮6', '男', '1990-01-03 00:00:00', '610122199001031456', '已婚', '1', '陕西', '3', 'zhao@qq.com', '15612347795', '陕西省西安市莲湖区', '92', '12', '34', '劳动合同', '高中', '电子工程', '哈尔滨理工大学', '2018-01-01 00:00:00', '在职', '00000054', 3.5, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2021-07-14 00:00:00', NULL);
INSERT INTO `employee` VALUES ('55', '姚森6', '男', '1991-02-05 00:00:00', '610122199102058952', '已婚', '1', '河南', '3', 'yaosen@qq.com', '14785559936', '河南洛阳人民大道58号', '92', '15', '34', '劳动合同', '初中', '室内装修设计', '西北大学', '2017-01-02 00:00:00', '在职', '00000055', 7, '2017-04-02 00:00:00', NULL, '2017-01-02 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('56', '云星6', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000056', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('6', '云星', '女', '1993-01-05 00:00:00', '610122199301054789', '已婚', '1', '陕西西安', '1', 'yunxing@qq.com', '15644442252', '陕西西安新城区', '92', '16', '34', '劳务合同', '硕士', '通信工程', '西安电子科技学校', '2018-01-01 00:00:00', '在职', '00000006', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('7', '贾旭明', '男', '1993-11-11 00:00:00', '610122199311111234', '已婚', '1', '广东广州', '4', 'jiaxuming@qq.com', '15644441234', '广东省广州市天河区冼村路', '78', '15', '33', '劳务合同', '初中', '通信工程', '西北大学', '2018-01-01 00:00:00', '在职', '00000007', 5.25, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2023-04-13 00:00:00', NULL);
INSERT INTO `employee` VALUES ('8', '张黎明', '男', '1991-02-01 00:00:00', '610144199102014569', '已婚', '1', '广东', '6', 'zhangliming@qq.com', '18979994478', '广东珠海', '91', '15', '33', '劳动合同', '高中', '考古', '清华大学', '2018-01-01 00:00:00', '在职', '00000008', 7, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2025-01-30 00:00:00', NULL);
INSERT INTO `employee` VALUES ('9', '薛磊', '男', '1992-07-01 00:00:00', '610144199207017895', '已婚', '1', '陕西西安', '13', 'xuelei@qq.com', '15648887741', '西安市雁塔区', '92', '14', '34', '劳动合同', '初中', '无', '华胥中学', '2018-01-01 00:00:00', '在职', '00000009', 6, '2018-04-01 00:00:00', NULL, '2018-01-01 00:00:00', '2024-01-17 00:00:00', NULL);
INSERT INTO `employee` VALUES ('97616148853424128KAX', '人参花', '男', '2019-11-04 00:00:00', '110224199709099878', '未婚', '1', '打算', '1', 'scen@vip.qq.com', '15518107074', 'ads 阿斯达', '89', '13', '29', '劳务合同', '博士', '德国人人', '分隔符', '2019-04-09 00:00:00', '在职', '00000057', 2.42, '2019-11-15 00:00:00', NULL, '2019-06-05 00:00:00', '2021-11-11 00:00:00', NULL);
INSERT INTO `employee` VALUES ('97624016688250880SEJ', '任振华', '男', '2008-11-05 00:00:00', '412715199810247658', '已婚', '1', '中国', '1', 'scen@vip.qq.com', '15518107074', '海淀', '8', '10', '34', '劳务合同', '本科', '计算器', '华水', '2019-11-04 00:00:00', '在职', '00000058', 6, '2019-11-07 00:00:00', NULL, '2016-11-07 00:00:00', '2022-11-04 00:00:00', NULL);
INSERT INTO `employee` VALUES ('97625832020770816UGI', '任仁华', '男', '2008-11-04 00:00:00', '412725199810247658', '已婚', '1', '每部哦', '1', 'scen@vip.qq.com', '15518107074', '海岸还会', '5', '14', '32', '劳务合同', '博士', '打发士大夫', 'dfdsf是的范', '2019-04-02 00:00:00', '在职', '00000059', 3.42, '2019-11-14 00:00:00', NULL, '2019-06-06 00:00:00', '2022-11-10 00:00:00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for employeeec
-- ----------------------------
DROP TABLE IF EXISTS `employeeec`;
CREATE TABLE `employeeec` (
  `id` varchar(32) NOT NULL,
  `eid` varchar(32) DEFAULT NULL COMMENT '员工编号',
  `ecDate` datetime DEFAULT NULL COMMENT '奖罚日期',
  `ecReason` varchar(255) DEFAULT NULL COMMENT '奖罚原因',
  `ecPoint` int(11) DEFAULT NULL COMMENT '奖罚分',
  `ecType` int(11) DEFAULT NULL COMMENT '奖罚类别，0：奖，1：罚',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for employeeremove
-- ----------------------------
DROP TABLE IF EXISTS `employeeremove`;
CREATE TABLE `employeeremove` (
  `id` varchar(32) NOT NULL,
  `eid` varchar(32) DEFAULT NULL,
  `afterDepId` varchar(32) DEFAULT NULL COMMENT '调动后部门',
  `afterJobId` varchar(32) DEFAULT NULL COMMENT '调动后职位',
  `removeDate` datetime DEFAULT NULL COMMENT '调动日期',
  `reason` varchar(255) DEFAULT NULL COMMENT '调动原因',
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for employeetrain
-- ----------------------------
DROP TABLE IF EXISTS `employeetrain`;
CREATE TABLE `employeetrain` (
  `id` varchar(32) NOT NULL,
  `eid` varchar(32) DEFAULT NULL COMMENT '员工编号',
  `trainDate` datetime DEFAULT NULL COMMENT '培训日期',
  `trainContent` varchar(255) DEFAULT NULL COMMENT '培训内容',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for empsalary
-- ----------------------------
DROP TABLE IF EXISTS `empsalary`;
CREATE TABLE `empsalary` (
  `id` varchar(32) NOT NULL,
  `eid` varchar(32) DEFAULT NULL,
  `sid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of empsalary
-- ----------------------------
BEGIN;
INSERT INTO `empsalary` VALUES ('97907434814701568SAZ', '97625832020770816UGI', '97896654539063296LWP');
COMMIT;

-- ----------------------------
-- Table structure for hr
-- ----------------------------
DROP TABLE IF EXISTS `hr`;
CREATE TABLE `hr` (
  `id` varchar(32) NOT NULL COMMENT 'hrID',
  `name` varchar(32) DEFAULT NULL COMMENT '姓名',
  `phone` char(11) DEFAULT NULL COMMENT '手机号码',
  `telephone` varchar(16) DEFAULT NULL COMMENT '住宅电话',
  `address` varchar(64) DEFAULT NULL COMMENT '联系地址',
  `enabled` tinyint(1) DEFAULT '1',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `userface` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hr
-- ----------------------------
BEGIN;
INSERT INTO `hr` VALUES ('10', '韩愈', '15518107074', '010-110', '广州番禺', 1, 'hanyu', '$2a$10$L2wv7NksWhljqlRaD2Vkj.FQE0ZWFTWwzb5/cbEjHjc9zgBKbJqdu', 'http://img1.doubanio.com/lpic/s26869937.jpg', NULL);
INSERT INTO `hr` VALUES ('11', '柳宗元', '15518107074', '010-110', '广州天河', 1, 'liuzongyuan', '$2a$10$L2wv7NksWhljqlRaD2Vkj.FQE0ZWFTWwzb5/cbEjHjc9zgBKbJqdu', 'http://img1.doubanio.com/lpic/s26869937.jpg', NULL);
INSERT INTO `hr` VALUES ('12', '曾巩', '15518107074', '010-110', '广州越秀', 1, 'zenggong', '$2a$10$L2wv7NksWhljqlRaD2Vkj.FQE0ZWFTWwzb5/cbEjHjc9zgBKbJqdu', 'http://img1.doubanio.com/lpic/s26869937.jpg', NULL);
INSERT INTO `hr` VALUES ('3', '系统管理员', '15518107074', '010-110', '深圳南山', 1, 'admin', '$2a$10$L2wv7NksWhljqlRaD2Vkj.FQE0ZWFTWwzb5/cbEjHjc9zgBKbJqdu', 'http://img1.doubanio.com/lpic/s26869937.jpg', NULL);
INSERT INTO `hr` VALUES ('5', '李白', '15518107074', '010-110', '海口美兰', 1, 'libai', '$2a$10$L2wv7NksWhljqlRaD2Vkj.FQE0ZWFTWwzb5/cbEjHjc9zgBKbJqdu', 'http://img1.doubanio.com/lpic/s26869937.jpg', NULL);
INSERT INTO `hr` VALUES ('6', '任振华', '15518107074', '010-110', '', 1, 'renzhenhua', '$2a$10$L2wv7NksWhljqlRaD2Vkj.FQE0ZWFTWwzb5/cbEjHjc9zgBKbJqdu', 'http://img1.doubanio.com/lpic/s26869937.jpg', NULL);
COMMIT;

-- ----------------------------
-- Table structure for hr_role
-- ----------------------------
DROP TABLE IF EXISTS `hr_role`;
CREATE TABLE `hr_role` (
  `id` varchar(32) NOT NULL,
  `rid` varchar(32) DEFAULT NULL,
  `hrid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hr_role
-- ----------------------------
BEGIN;
INSERT INTO `hr_role` VALUES ('1', '6', '3');
INSERT INTO `hr_role` VALUES ('10', '4', '5');
INSERT INTO `hr_role` VALUES ('35', '4', '12');
INSERT INTO `hr_role` VALUES ('36', '3', '12');
INSERT INTO `hr_role` VALUES ('37', '2', '12');
INSERT INTO `hr_role` VALUES ('43', '3', '11');
INSERT INTO `hr_role` VALUES ('44', '2', '11');
INSERT INTO `hr_role` VALUES ('45', '4', '11');
INSERT INTO `hr_role` VALUES ('46', '5', '11');
INSERT INTO `hr_role` VALUES ('48', '3', '10');
INSERT INTO `hr_role` VALUES ('49', '4', '10');
INSERT INTO `hr_role` VALUES ('9', '1', '5');
INSERT INTO `hr_role` VALUES ('98005794171125760QUM', '13', '6');
COMMIT;

-- ----------------------------
-- Table structure for joblevel
-- ----------------------------
DROP TABLE IF EXISTS `joblevel`;
CREATE TABLE `joblevel` (
  `id` varchar(32) NOT NULL,
  `name` varchar(32) DEFAULT NULL COMMENT '职称名称',
  `titleLevel` enum('正高级','副高级','中级','初级','员级') DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of joblevel
-- ----------------------------
BEGIN;
INSERT INTO `joblevel` VALUES ('10', '副教授', '副高级', '2018-01-11 21:19:20', 1);
INSERT INTO `joblevel` VALUES ('12', '助教', '初级', '2018-01-11 21:35:39', 1);
INSERT INTO `joblevel` VALUES ('13', '讲师', '中级', '2018-01-11 22:42:12', 1);
INSERT INTO `joblevel` VALUES ('14', '初级工程师', '初级', '2018-01-14 16:18:50', 1);
INSERT INTO `joblevel` VALUES ('15', '中级工程师', '中级', '2018-01-14 16:19:00', 1);
INSERT INTO `joblevel` VALUES ('16', '高级工程师', '副高级', '2018-01-14 16:19:14', 1);
INSERT INTO `joblevel` VALUES ('17', '骨灰级工程师', '正高级', '2018-01-14 16:19:24', 1);
INSERT INTO `joblevel` VALUES ('9', '教授', '正高级', '2018-01-11 21:19:14', 1);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(64) DEFAULT NULL,
  `path` varchar(64) DEFAULT NULL,
  `component` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `iconCls` varchar(64) DEFAULT NULL,
  `keepAlive` tinyint(1) DEFAULT NULL,
  `requireAuth` tinyint(1) DEFAULT NULL,
  `parentId` int(11) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES (1, '/', NULL, NULL, '所有', NULL, NULL, NULL, NULL, 1);
INSERT INTO `menu` VALUES (2, '/', '/home', 'Home', '员工资料', 'fa fa-user-circle-o', NULL, 1, 1, 1);
INSERT INTO `menu` VALUES (3, '/', '/home', 'Home', '人事管理', 'fa fa-address-card-o', NULL, 1, 1, 1);
INSERT INTO `menu` VALUES (4, '/', '/home', 'Home', '薪资管理', 'fa fa-money', NULL, 1, 1, 1);
INSERT INTO `menu` VALUES (5, '/', '/home', 'Home', '统计管理', 'fa fa-bar-chart', NULL, 1, 1, 1);
INSERT INTO `menu` VALUES (6, '/', '/home', 'Home', '系统管理', 'fa fa-windows', NULL, 1, 1, 1);
INSERT INTO `menu` VALUES (7, '/employee/basic/**', '/emp/basic', 'EmpBasic', '基本资料', NULL, NULL, 1, 2, 1);
INSERT INTO `menu` VALUES (8, '/employee/advanced/**', '/emp/adv', 'EmpAdv', '高级资料', NULL, NULL, 1, 2, 0);
INSERT INTO `menu` VALUES (9, '/personnel/emp/**', '/per/emp', 'PerEmp', '员工资料', NULL, NULL, 1, 3, 0);
INSERT INTO `menu` VALUES (10, '/personnel/ec/**', '/per/ec', 'PerEc', '员工奖惩', NULL, NULL, 1, 3, 1);
INSERT INTO `menu` VALUES (11, '/personnel/train/**', '/per/train', 'PerTrain', '员工培训', NULL, NULL, 1, 3, 1);
INSERT INTO `menu` VALUES (12, '/personnel/salary/**', '/per/salary', 'PerSalary', '员工调薪', NULL, NULL, 1, 3, 1);
INSERT INTO `menu` VALUES (13, '/personnel/remove/**', '/per/mv', 'PerMv', '员工调动', NULL, NULL, 1, 3, 1);
INSERT INTO `menu` VALUES (14, '/salary/sob/**', '/sal/sob', 'SalSob', '工资账套管理', NULL, NULL, 1, 4, 1);
INSERT INTO `menu` VALUES (15, '/salary/sobcfg/**', '/sal/sobcfg', 'SalSobCfg', '员工账套设置', NULL, NULL, 1, 4, 1);
INSERT INTO `menu` VALUES (16, '/salary/table/**', '/sal/table', 'SalTable', '工资表管理', NULL, NULL, 1, 4, 1);
INSERT INTO `menu` VALUES (17, '/salary/month/**', '/sal/month', 'SalMonth', '月末处理', NULL, NULL, 1, 4, 1);
INSERT INTO `menu` VALUES (18, '/salary/search/**', '/sal/search', 'SalSearch', '工资表查询', NULL, NULL, 1, 4, 1);
INSERT INTO `menu` VALUES (19, '/statistics/all/**', '/sta/all', 'StaAll', '综合信息统计', NULL, NULL, 1, 5, 1);
INSERT INTO `menu` VALUES (20, '/statistics/score/**', '/sta/score', 'StaScore', '员工积分统计', NULL, NULL, 1, 5, 1);
INSERT INTO `menu` VALUES (21, '/statistics/personnel/**', '/sta/pers', 'StaPers', '人事信息统计', NULL, NULL, 1, 5, 1);
INSERT INTO `menu` VALUES (22, '/statistics/recored/**', '/sta/record', 'StaRecord', '人事记录统计', NULL, NULL, 1, 5, 1);
INSERT INTO `menu` VALUES (23, '/system/basic/**', '/sys/basic', 'SysBasic', '基础信息设置', NULL, NULL, 1, 6, 1);
INSERT INTO `menu` VALUES (24, '/system/cfg/**', '/sys/cfg', 'SysCfg', '系统管理', NULL, NULL, 1, 6, 1);
INSERT INTO `menu` VALUES (25, '/system/log/**', '/sys/log', 'SysLog', '操作日志管理', NULL, NULL, 1, 6, 1);
INSERT INTO `menu` VALUES (26, '/system/hr/**', '/sys/hr', 'SysHr', '操作员管理', NULL, NULL, 1, 6, 1);
INSERT INTO `menu` VALUES (27, '/system/data/**', '/sys/data', 'SysData', '备份恢复数据库', NULL, NULL, 1, 6, 1);
INSERT INTO `menu` VALUES (28, '/system/init/**', '/sys/init', 'SysInit', '初始化数据库', NULL, NULL, 1, 6, 1);
COMMIT;

-- ----------------------------
-- Table structure for menu_role
-- ----------------------------
DROP TABLE IF EXISTS `menu_role`;
CREATE TABLE `menu_role` (
  `id` varchar(32) NOT NULL,
  `mid` int(11) DEFAULT NULL,
  `rid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menu_role
-- ----------------------------
BEGIN;
INSERT INTO `menu_role` VALUES ('161', 7, '3');
INSERT INTO `menu_role` VALUES ('162', 7, '6');
INSERT INTO `menu_role` VALUES ('163', 9, '6');
INSERT INTO `menu_role` VALUES ('164', 10, '6');
INSERT INTO `menu_role` VALUES ('165', 11, '6');
INSERT INTO `menu_role` VALUES ('166', 12, '6');
INSERT INTO `menu_role` VALUES ('167', 13, '6');
INSERT INTO `menu_role` VALUES ('168', 14, '6');
INSERT INTO `menu_role` VALUES ('169', 15, '6');
INSERT INTO `menu_role` VALUES ('170', 16, '6');
INSERT INTO `menu_role` VALUES ('171', 17, '6');
INSERT INTO `menu_role` VALUES ('172', 18, '6');
INSERT INTO `menu_role` VALUES ('173', 19, '6');
INSERT INTO `menu_role` VALUES ('174', 20, '6');
INSERT INTO `menu_role` VALUES ('175', 21, '6');
INSERT INTO `menu_role` VALUES ('176', 22, '6');
INSERT INTO `menu_role` VALUES ('177', 23, '6');
INSERT INTO `menu_role` VALUES ('178', 25, '6');
INSERT INTO `menu_role` VALUES ('179', 26, '6');
INSERT INTO `menu_role` VALUES ('180', 27, '6');
INSERT INTO `menu_role` VALUES ('181', 28, '6');
INSERT INTO `menu_role` VALUES ('182', 24, '6');
INSERT INTO `menu_role` VALUES ('247', 7, '4');
INSERT INTO `menu_role` VALUES ('248', 8, '4');
INSERT INTO `menu_role` VALUES ('249', 11, '4');
INSERT INTO `menu_role` VALUES ('250', 7, '2');
INSERT INTO `menu_role` VALUES ('251', 8, '2');
INSERT INTO `menu_role` VALUES ('252', 9, '2');
INSERT INTO `menu_role` VALUES ('253', 10, '2');
INSERT INTO `menu_role` VALUES ('254', 12, '2');
INSERT INTO `menu_role` VALUES ('255', 13, '2');
INSERT INTO `menu_role` VALUES ('256', 7, '1');
INSERT INTO `menu_role` VALUES ('257', 8, '1');
INSERT INTO `menu_role` VALUES ('258', 9, '1');
INSERT INTO `menu_role` VALUES ('259', 10, '1');
INSERT INTO `menu_role` VALUES ('260', 11, '1');
INSERT INTO `menu_role` VALUES ('261', 12, '1');
INSERT INTO `menu_role` VALUES ('262', 13, '1');
INSERT INTO `menu_role` VALUES ('263', 14, '1');
INSERT INTO `menu_role` VALUES ('264', 15, '1');
INSERT INTO `menu_role` VALUES ('265', 16, '1');
INSERT INTO `menu_role` VALUES ('266', 17, '1');
INSERT INTO `menu_role` VALUES ('267', 18, '1');
INSERT INTO `menu_role` VALUES ('268', 19, '1');
INSERT INTO `menu_role` VALUES ('269', 20, '1');
INSERT INTO `menu_role` VALUES ('270', 21, '1');
INSERT INTO `menu_role` VALUES ('271', 22, '1');
INSERT INTO `menu_role` VALUES ('272', 23, '1');
INSERT INTO `menu_role` VALUES ('273', 24, '1');
INSERT INTO `menu_role` VALUES ('274', 25, '1');
INSERT INTO `menu_role` VALUES ('275', 26, '1');
INSERT INTO `menu_role` VALUES ('276', 27, '1');
INSERT INTO `menu_role` VALUES ('277', 28, '1');
INSERT INTO `menu_role` VALUES ('97990957424705536JAM', 14, '97988160075595776OLQ');
INSERT INTO `menu_role` VALUES ('97990957588283392EMP', 15, '97988160075595776OLQ');
INSERT INTO `menu_role` VALUES ('97990957676363776ELQ', 16, '97988160075595776OLQ');
INSERT INTO `menu_role` VALUES ('97990957764444160DEM', 17, '97988160075595776OLQ');
INSERT INTO `menu_role` VALUES ('97990958108377088CHP', 18, '97988160075595776OLQ');
COMMIT;

-- ----------------------------
-- Table structure for msgcontent
-- ----------------------------
DROP TABLE IF EXISTS `msgcontent`;
CREATE TABLE `msgcontent` (
  `id` varchar(32) NOT NULL,
  `title` varchar(64) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of msgcontent
-- ----------------------------
BEGIN;
INSERT INTO `msgcontent` VALUES ('14', '2222222222', '11111111111111111', '2018-02-02 20:46:19');
INSERT INTO `msgcontent` VALUES ('15', '22222222', '3333333333333333333333', '2018-02-02 21:45:57');
INSERT INTO `msgcontent` VALUES ('16', '通知标题1', '通知内容1', '2018-02-03 11:41:39');
INSERT INTO `msgcontent` VALUES ('17', '通知标题2', '通知内容2', '2018-02-03 11:52:37');
INSERT INTO `msgcontent` VALUES ('18', '通知标题3', '通知内容3', '2018-02-03 12:19:41');
INSERT INTO `msgcontent` VALUES ('97547362506899456DLZ', '嘿嘿额黑我试试', '我来试一下', '2019-11-16 13:10:15');
INSERT INTO `msgcontent` VALUES ('97547778133065728YUS', '我再试一下', '我在是艺术萨达我', '2019-11-16 13:11:54');
COMMIT;

-- ----------------------------
-- Table structure for nation
-- ----------------------------
DROP TABLE IF EXISTS `nation`;
CREATE TABLE `nation` (
  `id` varchar(32) NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nation
-- ----------------------------
BEGIN;
INSERT INTO `nation` VALUES ('1', '汉族');
INSERT INTO `nation` VALUES ('10', '朝鲜族');
INSERT INTO `nation` VALUES ('11', '满族');
INSERT INTO `nation` VALUES ('12', '侗族');
INSERT INTO `nation` VALUES ('13', '瑶族');
INSERT INTO `nation` VALUES ('14', '白族');
INSERT INTO `nation` VALUES ('15', '土家族');
INSERT INTO `nation` VALUES ('16', '哈尼族');
INSERT INTO `nation` VALUES ('17', '哈萨克族');
INSERT INTO `nation` VALUES ('18', '傣族');
INSERT INTO `nation` VALUES ('19', '黎族');
INSERT INTO `nation` VALUES ('2', '蒙古族');
INSERT INTO `nation` VALUES ('20', '傈僳族');
INSERT INTO `nation` VALUES ('21', '佤族');
INSERT INTO `nation` VALUES ('22', '畲族');
INSERT INTO `nation` VALUES ('23', '高山族');
INSERT INTO `nation` VALUES ('24', '拉祜族');
INSERT INTO `nation` VALUES ('25', '水族');
INSERT INTO `nation` VALUES ('26', '东乡族');
INSERT INTO `nation` VALUES ('27', '纳西族');
INSERT INTO `nation` VALUES ('28', '景颇族');
INSERT INTO `nation` VALUES ('29', '柯尔克孜族');
INSERT INTO `nation` VALUES ('3', '回族');
INSERT INTO `nation` VALUES ('30', '土族');
INSERT INTO `nation` VALUES ('31', '达斡尔族');
INSERT INTO `nation` VALUES ('32', '仫佬族');
INSERT INTO `nation` VALUES ('33', '羌族');
INSERT INTO `nation` VALUES ('34', '布朗族');
INSERT INTO `nation` VALUES ('35', '撒拉族');
INSERT INTO `nation` VALUES ('36', '毛难族');
INSERT INTO `nation` VALUES ('37', '仡佬族');
INSERT INTO `nation` VALUES ('38', '锡伯族');
INSERT INTO `nation` VALUES ('39', '阿昌族');
INSERT INTO `nation` VALUES ('4', '藏族');
INSERT INTO `nation` VALUES ('40', '普米族');
INSERT INTO `nation` VALUES ('41', '塔吉克族');
INSERT INTO `nation` VALUES ('42', '怒族');
INSERT INTO `nation` VALUES ('43', '乌孜别克族');
INSERT INTO `nation` VALUES ('44', '俄罗斯族');
INSERT INTO `nation` VALUES ('45', '鄂温克族');
INSERT INTO `nation` VALUES ('46', '崩龙族');
INSERT INTO `nation` VALUES ('47', '保安族');
INSERT INTO `nation` VALUES ('48', '裕固族');
INSERT INTO `nation` VALUES ('49', '京族');
INSERT INTO `nation` VALUES ('5', '维吾尔族');
INSERT INTO `nation` VALUES ('50', '塔塔尔族');
INSERT INTO `nation` VALUES ('51', '独龙族');
INSERT INTO `nation` VALUES ('52', '鄂伦春族');
INSERT INTO `nation` VALUES ('53', '赫哲族');
INSERT INTO `nation` VALUES ('54', '门巴族');
INSERT INTO `nation` VALUES ('55', '珞巴族');
INSERT INTO `nation` VALUES ('56', '基诺族');
INSERT INTO `nation` VALUES ('6', '苗族');
INSERT INTO `nation` VALUES ('7', '彝族');
INSERT INTO `nation` VALUES ('8', '壮族');
INSERT INTO `nation` VALUES ('9', '布依族');
COMMIT;

-- ----------------------------
-- Table structure for oplog
-- ----------------------------
DROP TABLE IF EXISTS `oplog`;
CREATE TABLE `oplog` (
  `id` varchar(32) NOT NULL,
  `addDate` datetime DEFAULT NULL COMMENT '添加日期',
  `operate` varchar(255) DEFAULT NULL COMMENT '操作内容',
  `hrid` varchar(32) DEFAULT NULL COMMENT '操作员ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for politicsstatus
-- ----------------------------
DROP TABLE IF EXISTS `politicsstatus`;
CREATE TABLE `politicsstatus` (
  `id` varchar(32) NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of politicsstatus
-- ----------------------------
BEGIN;
INSERT INTO `politicsstatus` VALUES ('1', '中共党员');
INSERT INTO `politicsstatus` VALUES ('10', '九三学社社员');
INSERT INTO `politicsstatus` VALUES ('11', '台盟盟员');
INSERT INTO `politicsstatus` VALUES ('12', '无党派民主人士');
INSERT INTO `politicsstatus` VALUES ('13', '普通公民');
INSERT INTO `politicsstatus` VALUES ('2', '中共预备党员');
INSERT INTO `politicsstatus` VALUES ('3', '共青团员');
INSERT INTO `politicsstatus` VALUES ('4', '民革党员');
INSERT INTO `politicsstatus` VALUES ('5', '民盟盟员');
INSERT INTO `politicsstatus` VALUES ('6', '民建会员');
INSERT INTO `politicsstatus` VALUES ('7', '民进会员');
INSERT INTO `politicsstatus` VALUES ('8', '农工党党员');
INSERT INTO `politicsstatus` VALUES ('9', '致公党党员');
COMMIT;

-- ----------------------------
-- Table structure for position
-- ----------------------------
DROP TABLE IF EXISTS `position`;
CREATE TABLE `position` (
  `id` varchar(32) NOT NULL,
  `name` varchar(32) DEFAULT NULL COMMENT '职位',
  `createDate` datetime DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of position
-- ----------------------------
BEGIN;
INSERT INTO `position` VALUES ('29', '技术总监', '2018-01-11 21:13:42', 1);
INSERT INTO `position` VALUES ('30', '运营总监', '2018-01-11 21:13:48', 1);
INSERT INTO `position` VALUES ('31', '市场总监', '2018-01-11 21:13:56', 1);
INSERT INTO `position` VALUES ('32', '总经理', '2018-01-11 21:35:07', 1);
INSERT INTO `position` VALUES ('33', '研发工程师', '2018-01-14 16:07:11', 1);
INSERT INTO `position` VALUES ('34', '运维工程师', '2018-01-14 16:11:41', 1);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` varchar(32) NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `nameZh` varchar(64) DEFAULT NULL COMMENT '角色名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('1', 'ROLE_manager', '部门经理');
INSERT INTO `role` VALUES ('13', 'ROLE_test2', '测试角色2');
INSERT INTO `role` VALUES ('14', 'ROLE_test1', '测试角色1');
INSERT INTO `role` VALUES ('2', 'ROLE_personnel', '人事专员');
INSERT INTO `role` VALUES ('3', 'ROLE_recruiter', '招聘主管');
INSERT INTO `role` VALUES ('4', 'ROLE_train', '培训主管');
INSERT INTO `role` VALUES ('5', 'ROLE_performance', '薪酬绩效主管');
INSERT INTO `role` VALUES ('6', 'ROLE_admin', '系统管理员');
COMMIT;

-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary` (
  `id` varchar(32) NOT NULL,
  `basicSalary` int(11) DEFAULT NULL COMMENT '基本工资',
  `bonus` int(11) DEFAULT NULL COMMENT '奖金',
  `lunchSalary` int(11) DEFAULT NULL COMMENT '午餐补助',
  `trafficSalary` int(11) DEFAULT NULL COMMENT '交通补助',
  `allSalary` int(11) DEFAULT NULL COMMENT '应发工资',
  `pensionBase` int(11) DEFAULT NULL COMMENT '养老金基数',
  `pensionPer` float DEFAULT NULL COMMENT '养老金比率',
  `createDate` datetime DEFAULT NULL COMMENT '启用时间',
  `medicalBase` int(11) DEFAULT NULL COMMENT '医疗基数',
  `medicalPer` float DEFAULT NULL COMMENT '医疗保险比率',
  `accumulationFundBase` int(11) DEFAULT NULL COMMENT '公积金基数',
  `accumulationFundPer` float DEFAULT NULL COMMENT '公积金比率',
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of salary
-- ----------------------------
BEGIN;
INSERT INTO `salary` VALUES ('97896654539063296LWP', 2500, 5000, 200, 100, NULL, 2500, 0.07, '2019-11-17 00:00:00', 2500, 0.07, 2500, 0.07, '1技术部工资账套');
INSERT INTO `salary` VALUES ('97896654539063297LWP', 2500, 5000, 200, 100, NULL, 2500, 0.07, '2019-11-17 00:00:00', 2500, 0.07, 2500, 0.07, '2技术部工资账套');
INSERT INTO `salary` VALUES ('97896654539063298LWP', 2500, 5000, 200, 100, NULL, 2500, 0.07, '2019-11-17 00:00:00', 2500, 0.07, 2500, 0.07, '3技术部工资账套');
INSERT INTO `salary` VALUES ('97896654539063299LWP', 2500, 5000, 200, 100, NULL, 2500, 0.07, '2019-11-17 00:00:00', 2500, 0.07, 2500, 0.07, '4技术部工资账套');
INSERT INTO `salary` VALUES ('97896654539063300LWP', 2500, 5000, 200, 100, NULL, 2500, 0.07, '2019-11-17 00:00:00', 2500, 0.07, 2500, 0.07, '5技术部工资账套');
INSERT INTO `salary` VALUES ('97896654539063301LWP', 2500, 5000, 200, 100, NULL, 2500, 0.07, '2019-11-17 00:00:00', 2500, 0.07, 2500, 0.07, '6技术部工资账套');
COMMIT;

-- ----------------------------
-- Table structure for sysmsg
-- ----------------------------
DROP TABLE IF EXISTS `sysmsg`;
CREATE TABLE `sysmsg` (
  `id` varchar(32) NOT NULL,
  `mid` varchar(32) DEFAULT NULL COMMENT '消息id',
  `type` int(11) DEFAULT '0' COMMENT '0表示群发消息',
  `hrid` varchar(32) DEFAULT NULL COMMENT '这条消息是给谁的',
  `state` int(11) DEFAULT '0' COMMENT '0 未读 1 已读',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sysmsg
-- ----------------------------
BEGIN;
INSERT INTO `sysmsg` VALUES ('57', '14', 0, '3', 1);
INSERT INTO `sysmsg` VALUES ('58', '14', 0, '5', 1);
INSERT INTO `sysmsg` VALUES ('59', '14', 0, '10', 1);
INSERT INTO `sysmsg` VALUES ('60', '14', 0, '11', 0);
INSERT INTO `sysmsg` VALUES ('61', '14', 0, '12', 0);
INSERT INTO `sysmsg` VALUES ('62', '15', 0, '3', 1);
INSERT INTO `sysmsg` VALUES ('63', '15', 0, '5', 1);
INSERT INTO `sysmsg` VALUES ('64', '15', 0, '10', 1);
INSERT INTO `sysmsg` VALUES ('65', '15', 0, '11', 0);
INSERT INTO `sysmsg` VALUES ('66', '15', 0, '12', 0);
INSERT INTO `sysmsg` VALUES ('67', '16', 0, '3', 1);
INSERT INTO `sysmsg` VALUES ('68', '16', 0, '5', 1);
INSERT INTO `sysmsg` VALUES ('69', '16', 0, '10', 1);
INSERT INTO `sysmsg` VALUES ('70', '16', 0, '11', 0);
INSERT INTO `sysmsg` VALUES ('71', '16', 0, '12', 0);
INSERT INTO `sysmsg` VALUES ('72', '17', 0, '3', 1);
INSERT INTO `sysmsg` VALUES ('73', '17', 0, '5', 1);
INSERT INTO `sysmsg` VALUES ('74', '17', 0, '10', 1);
INSERT INTO `sysmsg` VALUES ('75', '17', 0, '11', 0);
INSERT INTO `sysmsg` VALUES ('76', '17', 0, '12', 0);
INSERT INTO `sysmsg` VALUES ('77', '18', 0, '3', 1);
INSERT INTO `sysmsg` VALUES ('78', '18', 0, '5', 0);
INSERT INTO `sysmsg` VALUES ('79', '18', 0, '10', 0);
INSERT INTO `sysmsg` VALUES ('80', '18', 0, '11', 0);
INSERT INTO `sysmsg` VALUES ('81', '18', 0, '12', 0);
INSERT INTO `sysmsg` VALUES ('97547362725003264AGV', '97547362506899456DLZ', 0, '10', 0);
INSERT INTO `sysmsg` VALUES ('97547362863415296LTY', '97547362506899456DLZ', 0, '11', 0);
INSERT INTO `sysmsg` VALUES ('97547362980855808LYH', '97547362506899456DLZ', 0, '12', 0);
INSERT INTO `sysmsg` VALUES ('97547363094102016QYE', '97547362506899456DLZ', 0, '3', 1);
INSERT INTO `sysmsg` VALUES ('97547363228319744VKU', '97547362506899456DLZ', 0, '5', 0);
INSERT INTO `sysmsg` VALUES ('97547778342780928LBU', '97547778133065728YUS', 0, '10', 0);
INSERT INTO `sysmsg` VALUES ('97547778443444224QMF', '97547778133065728YUS', 0, '11', 0);
INSERT INTO `sysmsg` VALUES ('97547778560884736DUV', '97547778133065728YUS', 0, '12', 0);
INSERT INTO `sysmsg` VALUES ('97547778627993600RPU', '97547778133065728YUS', 0, '3', 1);
INSERT INTO `sysmsg` VALUES ('97547778703491072PEV', '97547778133065728YUS', 0, '5', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
